USE [JJMC_BPMQA]
GO

/****** Object:  View [dbo].[DDDistributorTotalState]    Script Date: 4/15/2020 1:36:29 PM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

create view [dbo].[DDDistributorTotalState] as 
select 
field0001 as Id,
field0002 as DistributorGuid,
field0003 as FlowState,
field0004 as CreateDate,
field0005 as Comment,
field0006 as IsCurrent,
om.name as CreateBy
from formmain_0901
left outer join org_member om on om.id=field0007

GO

